Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableOE.PRODUCT_DESCRIPTIONS
DescriptionNon-industry-specific design, allows selection of NLS-setting-specific data

Columns

ColumnData TypeNullableDefaultDescription
PRODUCT_IDNUMBER(6, 0)not null Primary key column.
LANGUAGE_IDVARCHAR2(3)not null Primary key column.
TRANSLATED_NAMENVARCHAR2(150)not null  
TRANSLATED_DESCRIPTIONNVARCHAR2(4000)not null  

Primary Key

Primary KeyColumns
PRD_DESC_PKPRODUCT_ID, LANGUAGE_ID

Indexes

IndexTypeColumns
PROD_NAME_IX TRANSLATED_NAME

Check Constraints

Check ConstraintExpressionDescription
TRANSLATED_DESC_NN"TRANSLATED_DESCRIPTION" IS NOT NULL 
TRANSLATED_NAME_NN"TRANSLATED_NAME" IS NOT NULL 

Foreign Keys

RelationColumnReferenced Column
OE.PRODUCT_INFORMATIONPRODUCT_IDPRODUCT_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.